﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Reports.Employee
{
    public class Report1
    {
        public CrystalReport1 Load(TinyCinema.Bussiness.Login.Employee LoginInfo)
        {
            string sql = "select TenPB, MaNV, TenNV, NgaySinh, TenCV from PHONGBAN, NHANVIEN, CHUCVU where PHONGBAN.MaPB=NHANVIEN.MaPB and CHUCVU.MaCV=NHANVIEN.MaCV group by TenPB, MaNV, TenNV, NgaySinh, TenCV order by TenPB";
            CrystalReport1 report = new CrystalReport1();
            report.SetDataSource(TinyCinema.Data.Execution.Excute(sql));
            report.SetParameterValue("EmployeeName", LoginInfo.Emp.Name);
            return report;
        }
    }
}
